|
The Skyline operator is used in a query and performs a filtering of results from a database so that it keeps only those objects that are not worse than any other. This operator is an extension to SQL proposed by Börzsönyi et al. A classic example of application of the Skyline operator involves selecting a hotel for a holiday. The user wants the hotel to be both cheap and close to the beach. However, hotels that are close to the beach may also be expensive. In this case, the Skyline operator would only present those hotels that are not worse than any other hotel in both price and distance to the beach. == Proposed syntax == To give an example in SQL: Börzsönyi et al.〔 proposed the following syntax for the Skyline operator: SELECT ... FROM ... WHERE ... GROUP BY ... HAVING ... SKYLINE OF () d1 (| MAX | DIFF ), ..., dm (| MAX | DIFF ) ORDER BY ... where d1, ... dm denote the dimensions of the Skyline and MIN, MAX and DIFF specify whether the value in that dimension should be minimised, maximised or simply be different. 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Skyline operator」の詳細全文を読む スポンサード リンク
|